﻿CREATE VIEW [dbo].[EmployeeRole]
	AS SELECT Employee.Name, EmpRole.role_id, EmpRole.emp_role FROM Employee INNER JOIN EmpRole ON Employee.role_id = EmpRole.role_id